import sqlite3
conn = sqlite3.connect('test.db')
#创建游标
cursor = conn.cursor()
# 创建插入数据语句，在下面的for循环里逐条插入
DB_str = "select * from cutData"
o_db = cursor.execute(DB_str)
print(o_db)
print(type(o_db))   #<class 'sqlite3.Cursor'>
results = o_db.fetchall()
print(type(results))    #list

print(len(results))
for i in range(0,len(results)):
    #print(len(results[i]))
    #for a in range(1,len(results[i])):
    #print(results[i]['1])
    #print(results[i][0])
    queryData =results[i][1].split(',')
    print("queryData = ",queryData)

    # qdata = queryData.split(',')
    # print(qdata)

    # mainData = results[i][2]
    # print("mainData = ",mainData)
    # standard_data = mainData.split(',')
    # print(standard_data)


conn.commit()
conn.close()